IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[GetInfoEdProposalNumberByProtocolNumber]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.[GetInfoEdProposalNumberByProtocolNumber]
END
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
/******************************************************************          
* Name:   [GetInfoEdProposalNumberByProtocolNumber]          
* Purpose:  Gets the InfoEd Proposal Number(FolderNumber) by Protocol Number

* PARAMETERS          
* Name          Description               
* -------------      -------------------------------------------          
* @ProtocolNumber    Protocol Number (REQUIRED)          
*********************************************************************/ 
CREATE PROC [dbo].[GetInfoEdProposalNumberByProtocolNumber]
(
	@ProtocolNumber VARCHAR(25)
)
AS 
SET NOCOUNT ON
BEGIN

	SELECT * FROM dbo.Agreement_Protocol_Relate
	WHERE
	ProtocolNumber = @ProtocolNumber

END


